MSTemplate_Creator is an excel macro file created to provide users a more friendly interface to take in MRM transition names data exported directly from mass spectrometry software to create several annotation templates suited for automated data processing and statistical analysis.
It is currently distributed as platform independent source code under the MIT license.
Download the repository and open the excel macro file MSTemplate_Creator.xlsm
OpenMSTemplate_Creator
Upon opening you may encounter this security warning. Click on Enable Content so that the macro in the file will be activated.
EnableContent
Load transition names from Agilent MRM data in csv file with Load Transition_Name from Raw Data
Load Transition_Name from Raw Data
Load transition names from tabular data in csv file with Load Transition_Name from Table Data
Load Transition_Name from Table Data
Check the internal standards with Validate ISTD. Once validated, transfer the internal standards to sheet ISTD_Annot with Load ISTD to ISTD_Table